<!doctype html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport"
          content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>查询通讯录信息</title>
    <style>
        a{color: gray;text-decoration: none;}
        a:hover{color: red;}
        .new{width: 480px;text-align: right;}
        h1{color:red;}
        table{border:4px double red;border-spacing: 0;width: 480px;}
        th,td{border-bottom: 1px dotted red;border-right: 1px dotted red;padding: 6px 10px;}
    </style>
</head>
<body>
<h1>查询通讯录信息</h1>
<div class="new"><a href="new.php">注册新用户2</a></div>
<?php
$db=new PDO('mysql:host=localhost;dbname=db2;','root','12qwas');
$ps=$db->query('select * from students');
echo "<table><tr><th>学号</th><th>姓名</th><th>电话</th></tr>";
foreach ($ps as $r){
    echo "<tr><td>{$r['xh']}</td><td>{$r['name']}</td><td>{$r['tel']}</td></tr>";

}
echo '</table>';
?>
</body>
</html>